NewSpreadSheetAspose.java

package xlsx4j.workingwithworkbook;

import com.aspose.cells.Cell;
import com.aspose.cells.Cells;
import com.aspose.cells.Workbook;
import com.aspose.cells.Worksheet;
import com.aspose.cells.WorksheetCollection;

/**
 * @author Shoaib Khan
 */
public class NewSpreadSheetAspose
{
	public static void main(String[] args) throws Exception
	{
		//Instantiating a Workbook object
	    Workbook workbook = new Workbook();

		//Adding a new worksheet to the Workbook object
		WorksheetCollection worksheets = workbook.getWorksheets();
		Worksheet worksheet = worksheets.add("My Worksheet");
		
		Cells cells = worksheet.getCells();

		//Adding some value to cell
		Cell cell = cells.get("A1");
		cell.setValue("This is Aspose test of fonts!");

		//Saving the Excel file
	    workbook.save("data/xlsx4j/newWorksheet_Aspose.xls");
	    
	    //Print Message
	    System.out.println("Sheet added successfully.");
	}
}